package cn.com.yusys.yusp.admin.repository.mapper;

import cn.com.yusys.yusp.admin.domain.AdminSmLog;
import cn.com.yusys.yusp.commons.mapper.CommonMapper;
import cn.com.yusys.yusp.commons.mapper.QueryModel;

import java.util.List;
import java.util.Map;

public interface VillageInformationMapper extends CommonMapper<AdminSmLog> {
    //新客户建档
    int addVillage(QueryModel model);
    int addOtherIndustry(QueryModel model);
    int getCustomerCtfNo(QueryModel model);

    //新客户建档
    int excelAddNewCustomer(List<QueryModel> list);

    //查询所有的村庄信息
    List<Map<String, Object>> getAllVillageInformation(QueryModel model);

    //查询对应村的其他行业信息
    List<Map<String, Object>> getOtherIndustry(QueryModel model);
    List<Map<String, Object>> getVillageCustList(QueryModel model);
    List<Map<String, Object>> getOtherIndustryCustList(QueryModel model);

    List<Map<String, Object>> getGridName(QueryModel model);
    List<Map<String, Object>> getOrgName(QueryModel model);

    List<Map<String, Object>> getOtherIndustryName(QueryModel model);

    //查询客户经理的用户信息
    List<Map<String, Object>> getCustomerManagerVillageInformation(QueryModel model);

    //查询支行行长下属所有客户经理的用户信息
    List<Map<String, Object>> getSubBranchManagerVillageInformation(QueryModel model);

    //查询支行行长下属所有客户经理的用户信息
    List<Map<String, Object>> getBranchManagerVillageInformation(QueryModel model);

    //查询选定的用户信息
    Map<String, Object> getVillageInformation(QueryModel model);
    Map<String, Object> getVillageIndustryInformation(QueryModel model);
    //查看选定村的网格员信息
    Map<String, Object> getGridPersonnel(QueryModel model);
    Map<String, Object> getVillageDetail(QueryModel model);
    Map<String, Object> getVillageCustDetail(QueryModel model);
    Map<String, Object> getOtherIndustryCustDetail(QueryModel model);
    List<Map<String,Object>> getVillageCustDetailImage(QueryModel model);
    List<Map<String,Object>> getOtherIndustryCustDetailImage(QueryModel model);

    Integer updateCustomerImport(QueryModel model);

    Integer updateVillageInformation(QueryModel model);
    Integer updateOtherIndustry(QueryModel model);
    Integer updateGridPersonnel(QueryModel model);
    Integer addVillageDetail(QueryModel model);
    Integer addOtherIndustryDetail(QueryModel model);
    Integer deleteVillageImageById(QueryModel model);
    Integer deleteOtherIndustryImageById(QueryModel model);
    Integer addVillageImage(Map map);
    Integer addOtherIndustryImage(Map map);

    int deleteOtherIndustry(List<Integer> list);

    //查询已经存在的用户
    List<String> selectExistCustInfo(List<?> custNums);

    Map<String,Object> isExistCustomer(QueryModel model);

    String selectAppStatus(QueryModel model);

    int insertUserTransfer(QueryModel model);

    int insertProcessNode(QueryModel model);




}
